<template>
  <!-- 逻辑：在这个页面获取数据，通过props传参的方式给各个组件传参 -->
  <div class="report">
    <tableTool>
      <div slot="export">
        <el-button type="primary" @click="excelExport">导出</el-button>
      </div>
      <div class="tool-form" slot="form">
        <div class="input-group">
          <span class="lable">设备名称：</span>
          <el-input placeholder="请输入" v-model="filterEquipmentName" />
        </div>
        <div class="input-group">
          <span class="lable">设备类别：</span>
          <el-input placeholder="请输入" v-model="filterCategoryName" />
        </div>
        <el-button type="primary" @click="onSearch">搜索</el-button>
        <el-button type="success" @click="onReset">重置</el-button>
      </div>
    </tableTool>
    <customTable :list="list" :combined="combined">
      <template v-slot:title>
        <tr>
          <th colspan="17">{{ orgName }}</th>
        </tr>
        <tr>
          <th rowspan="2">设备编号</th>
          <th rowspan="2">设备名称</th>
          <th rowspan="2">规格型号</th>
          <th colspan="2">工程消耗</th>
          <th colspan="2">自行施工</th>
          <th colspan="2">机械消耗</th>
          <th colspan="2">研发支出</th>
          <th colspan="2">安全环保支出</th>
          <th colspan="2">分包扣款</th>
          <th colspan="2">销售消耗</th>
        </tr>
        <tr>
          <th>数量</th>
          <th>金额</th>
          <th>数量</th>
          <th>金额</th>
          <th>数量</th>
          <th>金额</th>
          <th>数量</th>
          <th>金额</th>
          <th>数量</th>
          <th>金额</th>
          <th>数量</th>
          <th>金额</th>
          <th>数量</th>
          <th>金额</th>
        </tr>
      </template>
      <template #body="{ list }">
        <tr v-for="item in list" :key="item.id">
          <td>{{ item.equipmentNumber }}</td>
          <td>{{ item.equipmentName }}</td>
          <td>{{ item.equipmentStandard }}</td>
          <td>{{ item.projectQuantity }}</td>
          <td>{{ item.projectAmount }}</td>
          <td>{{ item.selfQuantity }}</td>
          <td>{{ item.selfAmount }}</td>
          <td>{{ item.mechanicsQuantity }}</td>
          <td>{{ item.mechanicsAmount }}</td>
          <td>{{ item.developQuantity }}</td>
          <td>{{ item.developAmount }}</td>
          <td>{{ item.securityQuantity }}</td>
          <td>{{ item.securityAmount }}</td>
          <td>{{ item.subpackageQuantity }}</td>
          <td>{{ item.subpackageAmount }}</td>
          <td>{{ item.saleQuantity }}</td>
          <td>{{ item.saleAmount }}</td>
        </tr>
      </template>
      <template #empty>
        <tr>
          <td colspan="17" class="empty">暂无数据</td>
        </tr>
      </template>
      <template #footer="{ combined }">
        <tr>
          <td>合计</td>
          <td>{{ combined.equipmentName }}</td>
          <td>{{ combined.equipmentStandard }}</td>
          <td>{{ combined.projectQuantity }}</td>
          <td>{{ combined.projectAmount }}</td>
          <td>{{ combined.selfQuantity }}</td>
          <td>{{ combined.selfAmount }}</td>
          <td>{{ combined.mechanicsQuantity }}</td>
          <td>{{ combined.mechanicsAmount }}</td>
          <td>{{ combined.developQuantity }}</td>
          <td>{{ combined.developAmount }}</td>
          <td>{{ combined.securityQuantity }}</td>
          <td>{{ combined.securityAmount }}</td>
          <td>{{ combined.subpackageQuantity }}</td>
          <td>{{ combined.subpackageAmount }}</td>
          <td>{{ combined.saleQuantity }}</td>
          <td>{{ combined.saleAmount }}</td>
        </tr>
      </template>
    </customTable>
    <pagination @onCurrentChange="handleCurrentChange" :total="page.total"></pagination>
  </div>
</template>
<script>
import tableTool from '../components/tableTool.vue'
import customTable from '../components/customTable.vue'
import pagination from '../components/pagination.vue'
import { combinedFn } from '@/pages/comprehensiveReport/equipmentManagement/mixin'
import request from '@/api/comprehensiveReport/equipmentManagement.js'
export default {
  name: 'equipmentConstructionCostTableProject',
  components: { tableTool, customTable, pagination },
  data () {
    return {
      list: [],
      orgName: '',
      page: {
        total: 0,
        currentPage: 1,
        limit: 10,
      },
      combined: {},
      headers: {
        // 定义对应关系- 把英文的key转化成中文的key所对应的值，键名的可以随便取，为了区分建议取对应的名字
        设备编号: 'equipmentNumber',
        设备名称: 'equipmentName',
        规格型号: 'equipmentStandard',
        数量1: 'projectQuantity',
        金额1: 'projectAmount',
        数量2: 'selfQuantity',
        金额2: 'selfAmount',
        数量3: 'mechanicsQuantity',
        金额3: 'mechanicsAmount',
        数量4: 'developQuantity',
        金额4: 'developAmount',
        数量5: 'securityQuantity',
        金额5: 'securityAmount',
        数量6: 'subpackageQuantity',
        金额6: 'subpackageAmount',
        数量7: 'saleQuantity',
        金额7: 'saleAmount',
      },
      filterCategoryName: "",
      filterEquipmentName: ''
    }
  },
  created () {
    this.getList()
  },
  methods: {
    onSearch () {
      this.getList()
    },
    onReset () {
      this.filterEquipmentName = ''
      this.filterCategoryName = ''
      this.getList()
    },
    async getList () {
      const orgId = this.$route.query.orgId || localStorage.orgId
      this.orgName = this.$route.query.orgName || this.$store.state.userInfo.orgInfo.orgName
      const data = await request.getEquipmentConstructionCostDetails({
        page: this.page.currentPage,
        limit: this.page.limit,
        orgId,
        filterEquipmentName: this.filterEquipmentName,
        filterCategoryName: this.filterCategoryName
      })
      console.log('发送请求，获取数据', data)
      if (data.list.length == 0) {
        this.list = []
        this.combined = {}
        this.page.total = 0
        return;
      }
      this.page.total = data.totalCount
      const { list, combined } = combinedFn(Object.values(this.headers).slice(1), data.list, [
        'projectQuantity',
        'projectAmount',
        'selfQuantity',
        'selfAmount',
        'mechanicsQuantity',
        'mechanicsAmount',
        'developQuantity',
        'developAmount',
        'securityQuantity',
        'securityAmount',
        'subpackageQuantity',
        'subpackageAmount',
        'saleQuantity',
        'saleAmount',
      ])
      this.list = list
      this.combined = combined
    },
    handleCurrentChange (currentPage) {
      this.page.currentPage = currentPage
      this.getList()
    },
    excelExport () {
      const multiHeader = [
        [this.orgName, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''],
        [
          '设备编号',
          '设备名称',
          '规格型号',
          '工程消耗',
          '',
          '自行施工',
          '',
          '机械消耗',
          '',
          '研发支出',
          '',
          '安全环保支出',
          '',
          '分包扣款',
          '',
          '销售消耗',
          '',
        ],
      ] // 它是一个二维数组
      const merges = ['A1:Q1', 'D2:E2', 'F2:G2', 'H2:I2', 'J2:K2', 'L2:M2', 'N2:O2', 'P2:Q2', 'A2:A3', 'B2:B3', 'C2:C3']
      // 懒加载 script-loader
      import('@/utils/Export2Excel.js').then(async (excel) => {
        const orgId = this.$route.query.orgId || localStorage.orgId
        // 获取所有的数据
        const { list } = await request.getEquipmentConstructionCostDetails({
          paga: 1,
          limit: this.page.total,
          orgId,
        })
        // list就是所有的数据，list [{},{},{}] 转换为 => [[],[],[],[]]
        const data = this.formatJson(this.headers, list) // 转化数据表结构
        const { combined } = combinedFn(Object.values(this.headers).slice(1), list, [
          'projectQuantity',
          'projectAmount',
          'selfQuantity',
          'selfAmount',
          'mechanicsQuantity',
          'mechanicsAmount',
          'developQuantity',
          'developAmount',
          'securityQuantity',
          'securityAmount',
          'subpackageQuantity',
          'subpackageAmount',
          'saleQuantity',
          'saleAmount',
        ])
        data.push(['合计', ...Object.values(combined)])
        excel.export_json_to_excel({
          header: [
            '',
            '',
            '',
            '数量',
            '金额',
            '数量',
            '金额',
            '数量',
            '金额',
            '数量',
            '金额',
            '数量',
            '金额',
            '数量',
            '金额',
            '数量',
            '金额',
          ],
          data,
          filename: '设备管理-设备施工费用统计表-' + this.orgName,
          autoWidth: true,
          bookType: 'xlsx',
          multiHeader,
          merges,
        })
      })
    },
    formatJson (headers, list) {
      return list.map((item) => {
        return Object.values(headers).map((value) => {
          return item[value]
        })
      })
    },
  },
}
</script>
<style lang="scss">

</style>
